Hệ thống quản lý trường đại học bằng PHP
1 <?php require('../includes/config.php'); ?>
2 <!DOCTYPE HTML>
3 <html>
4 <head>
5 <title>Institut national des sciences appliquées et de technologie</title>
6 <meta charset="utf-8" />
7 <meta http-equiv="X-UA-Compatible" content="IE=edge">
8 <meta name="viewport" content="width=device-width, initial-scale=1">
9 <link href="../assets/css/bootstrap.css" rel="stylesheet">
10 <link rel="stylesheet" href="../assets/css/main.css" />
11 <link href="../assets/css/simple-sidebar.css" rel="stylesheet">
12 </head>
13 <body title="member">
14 <?php require('../includes/header.php'); ?>
15 <div id="wrapper">
16 <!-- Sidebar -->
17 <div id="sidebar-wrapper">
18 <ul class="sidebar-nav">
19 <li class="sidebar-brand">
20 <a href="../index_member.php">
21 Espace Membre
22 </a>
23 </li>
24 <li>
25 <a href="filiereSelec.php?type=C">Cours</a>
26 </li>
27 <li>
28 <a href="filiereSelec.php?type=AD">Anciens Devoirs</a>
29 </li>
30 <li>
31 <a href="filiereSelec.php?type=E">Exercices</a>
32 </li>
33 <li>
34 <a href="filiereSelec.php?type=R">Résultats</a>
35 </li>
36 </ul>
37 </div>
38 <!-- /#sidebar-wrapper -->
39 <!-- Page Content -->
40 <div id="page-content-wrapper">
41 <div class="container-fluid">
42 <div class="row">
43 <div class="col-lg-12">
44 <h1>Documents</h1>
45 </div>
46 <div class="row">
47 <div class="col-lg-12">
48 <div class="panel panel-default">
49 <div class="panel-heading">
50 <?php
51 $matiere = $_GET['matiereID'];
52 $type = $_GET['type'];
53 $filiere = $_GET['lvlID'];
54 if ($type=="C")
55 echo "Cours ";
56 elseif ($type=="AD")
57 echo "Anciens Devoirs ";
58 else
59 echo "Exercices ";
60 $req= $db->prepare('SELECT M.nom FROM Matiere M
61 WHERE M.matiereID = :matiereID');
62 $req->execute(array(':matiereID'=> $matiere));
63 $result= $req->fetch();
64 echo $result['nom'].' ' ;
65 $req= $db->prepare('SELECT * FROM Niveau INNER JOIN FiliereFullinfo
66 ON Niveau.filiereID = FiliereFullinfo.filiereID WHERE Niveau.lvlID= :lvlID ');
67 $req->execute(array(':lvlID'=> $filiere));
68 $result= $req->fetch();
69 echo $result['short_name'].' '.$result['valeur'];
70 ?>
71 </div>
72 <!-- /.panel-heading -->
73 <div class="panel-body">
74 <div class="dataTable_wrapper">
75 <table class="table table-striped table-bordered table-hover" id="dataTables-example">
76 <thead>
77 <tr>
78 <th>Nom</th>
79 <th>Auteur</th>
80 <th>date</th>
81 <th>View</th>
82 </tr>
83 </thead>
84 <tbody>
85 <?php
86 $stmt = $db->prepare('SELECT * FROM Documents
87 WHERE Documents.matiereID = :matiereID
88 AND Documents.lvlID = :lvlID
89 AND Documents.type = :type
90 ');
91 $stmt->execute(array(':matiereID'=> $matiere , ':lvlID' => $filiere,
92 ':type' => $type));
93 while($row = $stmt->fetch()){
94 ?>
95 <tr class="odd gradeX">
96 <td><?= $row['nom'] ?></td>
97 <td><?= $row['author'] ?></td>
98 <td><?= $row['date'] ?></td>
99 <td><a href=<?php echo "Documents/".$row['nom_sur_disque']?>><?= $row['nom_sur_disque'] ?></a></td>
100 </tr>
101 <?php
102 }
103 ?>
104 </tbody>
105 </table>
106 </div>
107 </div>
108 <!-- /.panel-body -->
109 </div>
110 <!-- /.panel -->
111 </div>
112 <!-- /.col-lg-12 -->
113 </div>
114 </div>
115 </div>
116 </div>
117 <!-- /#page-content-wrapper -->
118 </div>
119 <!-- /#wrapper -->
120 <!-- jQuery -->
121 <script src="../assets/js/jquery.js"></script>
122 <!-- Bootstrap Core JavaScript -->
123 <script src="../assets/js/bootstrap.min.js"></script>
124 <!-- Menu Toggle Script -->
125 <!-- Scripts -->
126 <script src="../assets/js/jquery.min.js"></script>
127 <script src="../assets/js/skel.min.js"></script>
128 <script src="../assets/js/util.js"></script>
129 <!--[if lte IE 8]><script src="assets/js/ie/respond.min.js"></script><![endif]-->
130 <script src="../assets/js/main.js"></script>
131 <!-- Include all compiled plugins (below), or include individual files as needed -->
132 <script src = "//maxcdn.bootstrapcdn.com/bootstrap/3.3.1/js/bootstrap.min.js"></script>
133 </body>
134 </html>